CREATE OR REPLACE PACKAGE "kesplus_app"."kes_plus_pkg_server_conn" AUTHID CURRENT_USER AS
    function add(jsonData text) return json;
    function del(ids varchar) return json;
    function update(jsonData text) return json;
    function update_trust_1(jsonData text) return json;
    function update_trust_0(jsonData text) return json;
    function update_switch_1(jsonData text) return json;
    function update_switch_0(jsonData text) return json;
    function find_byid(id_ varchar) return json;
    function findInfo(id_ varchar) return json;
    function list() return json;
    function find_with_child(id_ varchar) return json;
    function page(page integer, size integer) return json;
    TB_NAME VARCHAR := 'kes_server_conn';
    PK_COLUMN_NAME VARCHAR := 'id';
end;

CREATE OR REPLACE PACKAGE BODY "kesplus_app"."kes_plus_pkg_server_conn" AS WRAPPED
iDTzl03rSnVne/967IAocQMAoL9kVG+88OQhfa8kKfA4eok2AxbAai8ic2Js
UkCJ0IG0w9gfFQBq0aS/1uCDV3sIcqIWE9gs+aWaMLwtsmPXN6YisGWT0G2E
uHgmM5FoS09ng9V1bhZ6SXw5YoUahcsEHuvgwxpRWUFxWEV59YhygaKZjNGP
8GibS7IKtkpoKknWIEb7AOv3W2JJq+HO3FhrCJE2y9X8CRXoPq7kZHn0G2lO
9y5xv0Mx6pptMrpO/zgL/oBxrRy1CzeECwm2FxLHymTD5ae0wetgsUrzQAx4
Ho5Y9f5zhfvJ8W42gm7nleBsNAnZP2kbWIJjpcopRzxsCRHZo7ilrzpCBEfk
hYdxnboVm8wYy1QVuFWqE6pmx9+HbSiT/Pq781I/GoC4Kl+08N/G43m7hVWL
fAfdZzgBS10eMVFL+4wF17wvTBXuGvNlS+qrC3O+LimtTJwEGzl4T665Xhpz
YLAwQMlw4yt1lqD4IGj1fTtd65vuZtyYeUoehCJz/ZE+sIEgKT3DcHAt8UIW
NgkIKrWQITq1J26zdfGSsrv+cZoZlXyiMO5YRWjYPYCuTAkwmERBvwiYi4QB
gQa+4Xvwv0eKzR+/N99wLfFCFjYJCCq1kCE6tSduSi2znrPFl0rGguD8d0ON
OnWLLqQZa/78Nv70GH0a9nV56Q9bIXIqZwF1cnRN+CWgS0nMGQV2FXwMMKpS
P0LIvqGwMfw1DEQKc9pw/ROuZb9JawUiuo5k4wk+Tn4TKKmUyA7ivYqJS+Te
kK2gpYrfBf+TcJYj9dgSRp35WaRrpe341rsPdCFGcHLzpikhEXXb/N+tqH0k
7Zl2w7t+HxXvQYA6dCgWKK9DJiNe68wgb/9onx0BNhYqCbDueypMHjtNTS5L
N1zmDYVwihVS4W01ZxX461DMPs1+JYddqwVvnk5sq5mnSmFuRFBBGwI34bWh
uYwQUMJxdX21s2375k+xgROhwC4EvFKLvATm7x2OXLqDY2EMb/kbc1knBwm+
pM5IX8b7ASHDlXIkk9f6DbdD3FKzcb8C76jOs7f0P4avtA3QgbTD2B8VAGrR
pL/W4INX3ywB6PdWbkNYseCIObXL/xQ3n5ofzYHFpWh7s28/r3Bu1acDFwKN
iq2URAO4MDNCtBnmqkgqpQmiRG0H2yk68P+TcJYj9dgSRp35WaRrpe341rsP
dCFGcHLzpikhEXXbDD/r2/yATkJFSC8lUbe46uHROlOcJmubYNP58FwI8SeJ
3yS+OD+BJ1u18ZeVkX2diyYxN8OLAVsS1Nja3cLtr23bJMeanu1OPa2D5ugE
zO8C0SMGGu+BtiKYVI5i/6zv4Hcf6ug4Uec1YSWTsd8vg91fEQAcfY63X+Tr
NtfSg0j2DyqODaYpFTg4KRB8DGDgZLJ4xDA0Cqp/0PEmbUkuFJR4P5deTbUb
meqzsUWgf+6HBQl6tzHBeUfnzKpac9jiALK+6VVWLMvonOg2EUN6gtYlaR97
/z7zjFG8kZv3nHFxkApUzwYz+sg3BbifdVtUEJvXlWedDYRBrg1SPqoyCAP3
MB6yHq0FdGvYvRA/SeMqF1CeMcixcpiLQ9STIIwxUkwtD/aGfG9Y0gUoraNe
9CYeWyw7jvy2nHhcGWP5uAhlcG6Tu3o4NN4ZXyutE/ltbdskx5qe7U49rYPm
6ATM71fGXHcBs2moQlNX2wlv5QMQQRzaVrNa/bSp0paiAvY1Gmoj+Avpc1A1
wD7jfw74ozRlMskAuA74niJFbtJiVKgRM/DoN+iT2yz8UCsPoYnluuTP4yK6
6VFsNze6HPE5YFWiOfhTmjFPUgWiyTaArrSqj1NJrA5rf4bEcLwzuHm+toJK
UxTeldv8vlo0OBmvKIp6lpiSWbUHroUPuPprIwMpEUahSDzKbrXMnMorhGpp
fNvsCpBg7AQaV4D95kj0LA0uNZPV9PEO8MtGeKztktI1O8K/keZ3k2XDMdYC
j1P9ypMXZI/whbCCoPcC0v1HRsVXXFn1ltnA41UsjYBZvMSYEJ/eVhYhcsUE
Tntcp6J0hZunwtaatjBVDYktdMigsCiZJ04mGvYrHLK3z9raz7UjhTm6KSpx
oecC/GsPhYz/tk5owt2ZlitikmuUzzWyAREz8Og36JPbLPxQKw+hieW15dMD
2evtDbzwqFiM+ZCkOqU8Rn957hgJ34kwXfpjAkVo2D2ArkwJMJhEQb8ImIuE
AYEGvuF78L9His0fvzffcC3xQhY2CQgqtZAhOrUnbkots56zxZdKxoLg/HdD
jTp1iy6kGWv+/Db+9Bh9GvZ13crUwpR8bUa8yqh/YMCG6W8RhhNieK4SKLwS
eQ4fbTM5P2wdV6qxpuVaXpj6CpIjen07wNhFlu2IUWOlZ9/GfkJzDmrnq+e3
9sSAaseJuF9tvOMPoV+1Kjq9Mj3YQx1dM6Z4yV5AVrW4wiPM/rR6K+AZiGcq
yrhqrjagMeclqx7XwQiDcabLgsDJTqqUn/1cT6jNkyOOCzs1g0fJMCN2DpbM
U9bz/xaoo+cQ1VxMh0ylvKx70Bo0SRiCF6bHkJAtGl0u5s6kGT+1KzaI0OL/
6cRAY+bcC++mPpCijzGXQGDN4WjjZZcN1wq6hvZtSDKH5Jb034J7yTsnwjgT
Zsqf2Wob4ienMMNXNLpgvpus0NzozJsql2J47SG4r0RHDGEB6RAtF4EtUaUq
Nx/H/vAdhHGknecTZM+rjTbYjaRPSbiFhGSWPJMoYJX4oNn1L6vFgFQ9ANTB
ZqfS9G73nszSqo0i0uNLQSJ9O73Qiqte4WYlc2RxqhheDsHG1a27d70YS0nM
GQV2FXwMMKpSP0LIvufiXjgKTcml/gh6yWfI969G1QicwMJvRcKfaC0K7Ktt
nAiV9sNKTQosFO/AlLx4YnBJ6umUb2dOZ+ZpvQ5oaAJ0ydRc0A4EZp0cdgmW
+kPfPSbVR21a9zx/X4JorXxval/j3BX48GkOhnZFmxOmlrpRJAGQXpV+gtGL
X+/i/WOzPGwJEdmjuKWvOkIER+SFh3VH9bFSR6xXpF/YIj/ZtNfd57L0Cwz9
t63VLTwE/RhG2qtA++58ENBdd9Ng65WQMvOvBF8tfTeESgHhMDSDNmcYKNzW
Q34a1Zjly/u8Pcj8gP/TVRnOPMHQMgSiZyNOPKNl9oewu7WIWFPjyEONch3E
1+ROJ6FbaKwAqaGXs9NeU/rIrfCjd947ppQNmlLfVCrdE2VcBbxuP+q49cHY
mwBynaT4T3fxVStbf+oyJ9aeShsPeLLks//lCkV/UNj/LCKNfdtTMdMcpmZk
JYCojTKjr0/FzNAoXPx1jVHRBUOCV2yNsyWJce6z+bb9Jb0mKXeRyUj148+G
V3lt3CJHjkzLn52xIkfY286dNVVGaCZedNKQtH9UP6Ko9DoLZzIxnoJqkaPc
mDbtDp96DVS/M6A0ZTLJALgO+J4iRW7SYlSoETPw6Dfok9ss/FArD6GJ5ZdI
Mnq6w1ztY6iMclGMaPdwLfFCFjYJCCq1kCE6tSduogTPRgxfFVYJF7cXdudl
oGob4ienMMNXNLpgvpus0NzvQiP2mIegRHaMTA2nE5OOkdsc8DTivYNLoF2/
lkzuwQ7vjXBOg5q8/9f8FK8zHxmEYAJF+nNGbLxA4NZdPKhEY7i/eHEuaq6j
MeZ1qkpKczhsoezOssDvMdevTKTAP+b3GcipkKvDNIoafYLb2B9UQi5BFWdm
u2NiYGSw0aoRH+pb4ZEA94G3qeLNgUr7YY+EA9BhhKtYOhEJERkOmS75QS5m
/VbLjXJCX9mGqKDu2GQFiJXBAqbxWA8vN3gbPkTw4vZa8957ZOYgHk/Kc43C
8OL2WvPee2TmIB5PynONwi1tpJoZBAGioej4xPlizv6VPVN3qNTPRO24jOc4
d7ZdtWUmNDQULivhuhDZ9+/ezmOOFx7M3qYHgBjj67JEWrThVY+VW290hvtM
ECps2nGU8OL2WvPee2TmIB5PynONwvDi9lrz3ntk5iAeT8pzjcLw4vZa8957
ZOYgHk/Kc43CIo/gf5+rCZ1QxN2hnaDInLtj191f2eQqd74KYyJHjkLErTIW
nLbMTxcJzw2MHxU+Mvej0UFr76FMYzTD+LmvnvDi9lrz3ntk5iAeT8pzjcLw
4vZa8957ZOYgHk/Kc43C8OL2WvPee2TmIB5PynONwvDi9lrz3ntk5iAeT8pz
jcLxeNqGTWvlaCcAthV6YnoKvM1/yHab33gkHx7GflVBO/Gn6bozKmxxEGhb
MWe/JO6eZh7rQL/Fl7z2BPWDlF91QBXRU3VI2OJYoQ1bj9ifuhmICBsrsD/z
GValNmM6v4qKjs7ncLg5O/dLAgXKq5Id8OL2WvPee2TmIB5PynONwvDi9lrz
3ntk5iAeT8pzjcLw4vZa8957ZOYgHk/Kc43CvsE/aaXkeFRxlwF7ieyQc/Di
9lrz3ntk5iAeT8pzjcLw4vZa8957ZOYgHk/Kc43C8OL2WvPee2TmIB5PynON
woVyGVfo7JAoPIQCInar6ND8p5vZVRWLeVjNCjdYysnshJSr2iKXrjCyyM5z
ItPT654pS0cHp92sWKqwLnjWU4bqMcH5A5SeeRpt1UIb8luU8OL2WvPee2Tm
IB5PynONwvDi9lrz3ntk5iAeT8pzjcI/SgyyMyPL4EIftmtexl8ZDV+BIugG
FutdxMGW5pA2/PPxcqADJT3XF+UEwEaE6jRztLTSzJiU40hJ0uHz4tOrEXao
+tQVjHp1Z7tlybf+kfDi9lrz3ntk5iAeT8pzjcLw4vZa8957ZOYgHk/Kc43C
8OL2WvPee2TmIB5PynONwvDi9lrz3ntk5iAeT8pzjcIA1P3jh2wFU2A1ITeG
uKxAAbzpfZSYSmWjyYEfxwUPiXRERSITqejbw0Qkl0vY8qmU72/u2TV9h3cO
xR260dLxViG4jTjIc6RQyQayfjvdR3+iiTgG4NJ8kLcy5HK6TXH8q9PkB++o
vb0AebI68Ph78OL2WvPee2TmIB5PynONwvDi9lrz3ntk5iAeT8pzjcJA4tep
x1JptjZtljxtDhpasZ72lKTph98dhWmnRuqQ4xJq8NOwKcPsXRihhApGbgBF
NmGqp+W2Ii37qevYTQx+La19yugW2/uITVCxLLrsXnIYpFGFtBotjLcWCpTo
QGgWNma03pPWOGavCBiY+hqD27cyHWWzLWnsQNgCn2Vt1NflBvguxr7a6wfp
JqfSLChq1Oez9QqBGeati62Ndkqo18EIg3Gmy4LAyU6qlJ/9XD7Wj+hMYPdm
lf4ysz62SqvXaZCuAtbhBqeIUbEMK8m7lTw7c1Lbxcdj4euTHrGhcc/t21A1
o7FJDAyziSJFm8olLGwKMro5O+fOAliN7SlIIb/maU3CCi2a9n+3/17y6crt
AU8KqfmVk8skETzgioLx+LOZXZKmqF53t6ITS2DGI9XVOUG0v3qlE0lpBUqe
PMXwdDf8f60sNTyLqVfcXBe96EgCT9XHLxOwfB03k/bO5dxEitbbNCp+N2Lo
Jim2BbS1NvQ6U21ecS8ceylRYwilbPTjlE65Y/WeoSUL42rSZ9SjwxZQLN87
VkeNupP7JLkNQBzv88l2FQfKEiVybDx3lo27ptO22k28Zb2la9YHQ3K3VqkU
4TLZqWGw0lD7DWpaY8faqnDS9ErzyY2Va9JQIytbDIs1c5sRBpib5n3GXpDz
6Mb6Rof8QX/+VNa/YlwZn2uwYyrk+AKMUs5/7P4NpjT2fqbZdXWzOIay7HG4
jw1ZNQkJWxz5V7xx3cexA2O4v3hxLmquozHmdapKSnMuSpgEok0erZj+nnCu
/2mxQkYSkx72DqcG8/WU0kJE0LPu/p+LI/YONDrLq76NoGz33TrUMCgsFl3m
0jNb1+Acrw5L9H+6SbZrrEEFVwJijbf5DfcCOST+EXubb1m+UQltLh1sW1kg
DXXP8hMDuiGo+H8mTN8Rm9NmaJ7M+twijwz+H7YvmjvI6390CnGgZK+QYU7f
yoacqSMttgGCsPqFNDMifNguX9fahbU+maLGTCYVhs4J6u0JnOR1pwvdtoV1
Y8ERrXf7Q8f3rWntDiM1ugsHXOflXA/J8v1PjkHGk2+tPWLGu09vkpk9mSQ8
29HrbOTwsiLmDqvBCQRfUY/Qm43h2vrQTj+Tk0KZ6tp9G0kkVpeCqxhMUQra
x9Q0giQIaOmrD3BrBPFaDUvTt6Fr3pvJC4vdwzE/6UdtvSZv5e6xG7ms2Bnw
2ptPDk9xbmgx7vQRhyXcaHmRTdgmIDOWYdn6grkoCINXsURD3hWtzAcOQr/M
CcNUrj398b1jICdBCNP/4wdcU9CrqYeR/HK0mdr0EZXTLgglzfoLgTHNrkkH
+UM2VKXXfIj6xln7gcjodUeQPyI1FocxV/+X5uB/D+wUhIsX7BB/ZYFdLSzC
KFEpWaYKVGj8xgzXPTF/gLH1C+e+X0BxqiKAOoCj6dV1mGXmWgfsJAzCIXCY
Ga//kHKQIA+ycZ/iK67mAYnkphAFHMIYkCg1xnGw9JsbYZIgqJyuVzhRmMgn
dnibxdG+ykkH+UM2VKXXfIj6xln7gcjhoyX2yBKZ+ZZdGVxOm0zY4ZrP6m+p
8ChOqkoTSrOry77L/jcSbyA5ZTxlVDh3LYx5+nyUNFumHxoIb+2D3t5iUsZx
ozwIThwj9835QVm8jxIzLE+llFxzt28ph5N8bfQFZ7HKTrCndLHA/EdhI9gv
UlnKzw45sOgCgLXXPrdhpUaW1aEKKPl0sre/UffH4TetkfQGvqmYDTnAn6rA
N8de/1VVAo8XtefqfpAVlyINqwcIkNXsLS9S7NaNQ2+GjBmadF5zqYRDv91m
sxoHQ81dWE6NOZYnMZvOMX+s2lDiP8qh37AakmAjF9iXI4j4a7CKV0/zXzuh
67/vYCOb8JbAP8MOII7u7ie47vqnDhK8ADGlR5EA40t2Y0anG2gyu2WG5oIL
j6hHLorVUavFMFf4CW9TaIf5QvYQEzOSFUxLsA8FoKKNhSBadsEjKATM+yHb
pHbSxqeoaeIXeJTjtCj7NhhFmGLsJUYbHlYNP58llc6pg7S6dlnSxJiN27bU
LbSgOqk7QiBDlYUvNotoHT0Sp3kA5CAGPiquSqukPtXy8KHoNop/eoS/kf+T
3z6rHkOk5mY8WYNyUqhqDhkKyG3Wlc1N9iN0O+QnTf5BouOh+okQybUhzhVd
1tElx+gf1cZ8DP8ZUFeW0HGW758rBn6Fztc2DVail+kh7Y2Cy7n9HOByxqjW
ERXR+HrVi8LyNfjYt+S6dQbtmuJWIf6E8ZvaB1rcVA/ANiJhw9eB28ArlClw
Q6ZceF//RIDVpLC7cR5GPl14Ko1NRasFP3QSPZpHPcMaXbvq4VjMAtjRuX5g
FmUkyDuxhc8hoxwFVSq1x9P+pjA9oPThIUFV4k0hdxSVfA9FvosZiM9JXwNM
4N7RbkVZkFU1kPMRK59YF9RLe8+vuMc9SLZI8WmWoKfqWldlbzMi6EF7Q8tG
6f8fhI8kTbPJ83JX2sryyyB4+HOtVq1lSKTRqPKi5xc26O0fIm8aGxg0utZ8
ObUJKsSRqeoFfMR5Vc36lkn0rj41YmjSs2NveKDiEIh5UfbuR/Kd/ayRVFZU
Z4m8NGN+q5Bst6tcwF3sy6XbyZ4WKlPEj1TOJydkdC0bxrcYRKwlsYHYIgJ/
oC0yrH3Bw/Yo1U+v6OgSQydLgsBNcsoh5o9G0s8cy6o6RBjfekdUmb6kBYR6
8riJ6/2morzmJ6gKWjHFyVamDJgPHfQ7ekcxjK0DdkFmfCyCD2XsYxQJ1H+8
iKtXEbgJrbHeAb1x/xNCelISsVFOQbsFJZWkS1JjHndsylAk1qT/AEpv8SG4
a5oH03ecrsnWVlMCzwM4XOQFtqHZMpF9IDJQWyQ8alIk9ctldfxDFEVKphCa
3cTUnDNUjxpXWvMUa4o89sTzBo4EwD/THtDH7YXH8PGjh/P0DcyxZet1lb9d
YROBjBQeSCa5T/dhQgabeRzIqTmGIn8YIwDCAJ3bcGOidKbCauvuTmHVuE9O
vV9Uz2zrxKNFvyclcDQI0XAS+uzH9V5rf1pc9M1vaNaNh3sATiDN/HSiq3j3
Qht3BoUKTvjEZAKfkQXowUU8PBDINJWpzBua5kBJxpH6F+JXS2SPETKkcim8
I9cProgvfFmp/YxGhOU0Xdv43G6Lk0LFdS+Uc8yliStKtInhBp/v68W3hkaL
hSiQQpxN/W22E1rdV+Tg50nJNP/IyF8U58kbnWFyxTlxH/IC8X3qPOOeuglt
zYekR5gFX8qFK/zmnja5ZutlV/Kz5vv8IJbY+4wLhOzyKHwlJdYyUeRY1h44
bd5SfojI79zGDb5ghG9wzjdhEslNjrBqZacfVjxcUWTWGeLwRJ/syx2Cl44f
pE7fiWkM0CDGmWDdI+GdmumMYCdRWF1ceADAfQTNNk1xxLXyL7wLvXqvrLuf
/CAp0ik4TPnbjDfhFkFQwwCgYIcX3IrRcMDvp+75f54NfF1cbjAG/GXQczfj
5rNVtpVcgGOdI9HJk8/J49xucGqfBDDtfGfw4vZa8957ZOYgHk/Kc43CgVkV
fxktQaIka21ertrzcxQdgtAow/jp6eSJ7FNfrH8lRvfTh+I7rkRnr9gYCJEb
hY+kdgc/E9WYfMuh/h45jQPMrILv0QStakIWqwi4wtfENb8YenDXFu+FTjrK
gON0/SNpmSAsYEXqy7aQrrJ9LUz0G5hl8NWqqrLIM1IJiAYFV5Z3QmdoP4BE
MyvHHUIc3ngLC6YmW0kVw6xpvlZqJso6zeq275QKyU1qqIkBsdjw4vZa8957
ZOYgHk/Kc43CIo/gf5+rCZ1QxN2hnaDInAtIPLK7LCPBq05pjTkdMt4NX4Ei
6AYW613EwZbmkDb8AialJPscVasMFrZ5P75ZI62ENFrzfGjz6C1IL9nUulma
0wloZd9iz3dlNcGpdx7YJnyfBQbXUEfQKEwkm4VcDKuVLxtwl3aBkolcANxl
XfAI1CSUvve+Pt6vQhfBkke78OL2WvPee2TmIB5PynONwktRc790WmzCc/xg
gl2ETuJkBYiVwQKm8VgPLzd4Gz5E0/XJS0Ev5mPTX4/fB2X984KhAIIizIBq
UQb7l+klOwF9qZOj8Xc/6pMinYbAffYNaBcqftJXXw/iX9F//vJNZ8AhqFxi
csC4DPFXQCcyo9BGN/9yqDgnfN5rtL9S7douzDEpvzguG/774xAWt28cWl8D
hOs/936WpfzXu0xM/L174If2dmm5dQYToHCh/X9lz+3bUDWjsUkMDLOJIkWb
yijnB8RKPxj9wxG5eHYwZyemDt8Lw1GSvEirvPWsamoyGRabHMoMgKID663K
hA+x0hbzU0bNVHfUTWXkxfd96YvtWpA72zOTPue8OpI5zZyz
END;

